package com.merck.service.export;

import java.util.HashMap;
import java.util.LinkedHashMap;
import java.util.Map;

public class TitleMap {
    /**
     * 季度表头
     * @param excelName
     * @return
     */
    public static Map<String, Map<String, String>> getTitleMap(String excelName) {
        Map<String,Map<String, String>>  mapTitle = new LinkedHashMap<>();
        Map<String, String> mapField = null;
        //2021 Q1 Quarterly KPI Report OBU
        if ("QOBU".equalsIgnoreCase(excelName)) {
            //sheet KPI_OBU_REP_Erbitux
            mapField = getBaseTitle();
            mapTitle.put("KPI_OBU_REP_Erbitux", mapField);
            mapField.put("actual_work_days_ratio_m1_p", "实际工作天数比率-1");
            mapField.put("actual_work_days_ratio_m2_p", "实际工作天数比率-2");
            mapField.put("actual_work_days_ratio_m3_p", "实际工作天数比率-3");
            mapField.put("target_hcps_m1", "目标医生数-1");
            mapField.put("target_hcps_m2", "目标医生数-2");
            mapField.put("target_hcps_m3", "目标医生数-3");
            mapField.put("ab_call_hcps_ratio_m1_p", "AB目标客户覆盖率-1");
            mapField.put("ab_call_hcps_ratio_m2_p", "AB目标客户覆盖率-2");
            mapField.put("ab_call_hcps_ratio_m3_p", "AB目标客户覆盖率-3");
            mapField.put("call_hcps_ratio_m1_p", "总目标客户覆盖率-1");
            mapField.put("call_hcps_ratio_m2_p", "总目标客户覆盖率-2");
            mapField.put("call_hcps_ratio_m3_p", "总目标客户覆盖率-3");
            mapField.put("daily_actual_calls_m1", "每日平均拜访次数-1");
            mapField.put("daily_actual_calls_m2", "每日平均拜访次数-2");
            mapField.put("daily_actual_calls_m3", "每日平均拜访次数-3");
            mapField.put("is_new_binding_hcps_q", "新绑定医生数 ");
            mapField.put("is_binding_hcps_ratio_q_p", "已绑定医生占比");
            mapField.put("is_binding_weshare_hcps_m1", "Weshare推送已绑定医生数-1");
            mapField.put("is_binding_weshare_hcps_m2", "Weshare推送已绑定医生数-2");
            mapField.put("is_binding_weshare_hcps_m3", "Weshare推送已绑定医生数-1");
            mapField.put("product_test_q", "季度产品知识考试成绩");
            mapField.put("department_meeting_quality_m1", "科室会质量-1");
            mapField.put("department_meeting_quality_m2", "科室会质量-2");
            mapField.put("department_meeting_quality_m3", "科室会质量-3");
            mapField.put("actual_work_days_ratio_score_q_p", "实际工作天数比率得分");
            mapField.put("ab_call_hcps_ratio_score_q_p", "AB目标客户覆盖率得分");
            mapField.put("call_hcps_ratio_score_q_p", "总目标客户覆盖率得分");
            mapField.put("daily_actual_calls_score_q_p", "每日平均拜访次数得分");
            mapField.put("is_new_binding_hcps_score_q_p", "新绑定医生数得分");
            mapField.put("is_binding_hcps_ratio_score_q_p", "Weshare推送已绑定医生数得分");
            mapField.put("product_test_score_q_p", "季度产品知识考试成绩得分");
            mapField.put("department_meeting_quality_score_q_p", "科室会质量得分");
            mapField.put("expense_management_score_q_p", "费用管理得分");
            mapField.put("total", "总得分");
            ///sheet KPI_OBU_REP_Xalkori
            mapField = getBaseTitle();
            mapTitle.put("KPI_OBU_REP_Xalkori", mapField);
            mapField.put("product_test_q", "季度产品知识考试");
            mapField.put("ab_call_hcps_ratio_q_p", "客户覆盖率（AB级）");
            mapField.put("actual_calls_m1", "月度拜访 -1");
            mapField.put("actual_calls_m2", "月度拜访 -2");
            mapField.put("actual_calls_m3", "月度拜访 -3");
            mapField.put("joint_promotion_rate_score_q_p", "联合推广医院季度达成率得分");
            mapField.put("sample_testing_rate_score_q_p", "独立拜访医院样品检测指标季度达成率得分");
            mapField.put("product_test_score_q_p", "季度产品知识考试得分");
            mapField.put("ab_call_hcps_ratio_score_q_p", "客户覆盖率（AB级）得分");
            mapField.put("monthly_actual_calls_score_q_p", "月度拜访得分");
            mapField.put("total", "总得分");
            ///sheet KPI_OBU_DSM
            mapField = getBaseTitle();
            mapTitle.put("KPI_OBU_DSM", mapField);
//            mapField.put("avg_kpi_score_q_p", "下属代表KPI平均分 ");
            mapField.put("avg_kpi_value_q_p", "下属代表KPI平均分 ");
            mapField.put("actual_work_days_ratio_m1_p", "实际工作天数比率-1");
            mapField.put("actual_work_days_ratio_m2_p", "实际工作天数比率-2");
            mapField.put("actual_work_days_ratio_m3_p", "实际工作天数比率-3");
            mapField.put("coaching_quality_m1", "对代表的辅导质量-1");
            mapField.put("coaching_quality_m2", "对代表的辅导质量-2");
            mapField.put("coaching_quality_m3", "对代表的辅导质量-3");
            mapField.put("coaching_times_m1", "对代表的辅导频率-1");
            mapField.put("coaching_times_m2", "对代表的辅导频率-2");
            mapField.put("coaching_times_m3", "对代表的辅导频率-3");
            mapField.put("core_hospital_rate_q", "核心医院覆盖率");
            mapField.put("ems_rate_q", "EMS使用率");
            mapField.put("product_test_q", "季度产品知识考试 ");
            mapField.put("avg_kpi_score_q_ps", "下属代表KPI平均分得分 ");
            mapField.put("actual_work_days_ratio_score_q_p", "实际工作天数比率得分 ");
            mapField.put("coaching_quality_score_q_p", "对代表的辅导质量得分 ");
            mapField.put("coaching_times_score_q_p", "对代表的辅导频率得分 ");
            mapField.put("core_hospital_rate_score_q_p", "核心医院覆盖率得分 ");
            mapField.put("ems_rate_score_q_p", "EMS使用率得分 ");
            mapField.put("product_test_score_q_p", "季度产品知识考试得分 ");
            mapField.put("expense_management_score_q_p", "费用管理得分 ");
            mapField.put("total", "总得分 ");
            //sheet KPI_OBU_RSM
            mapField = getBaseTitle();
            mapTitle.put("KPI_OBU_RSM", mapField);
            mapField.put("avg_kpi_value_q_p", "下属平均KPI ");
            mapField.put("avg_kpi_score_q_ps", "下属平均KPI得分 ");
            mapField.put("turnover_rate_score_q_p", "团队季度离职率得分 ");
            mapField.put("expense_management_score_q_p", "销售费用管理得分 ");
            mapField.put("forecast_accuracy_score_q_p", "销售预估准确性得分 ");
            mapField.put("management_assessment_score_q_p", "销售队伍管理评估得分 ");
            mapField.put("total", "总得分 ");


        } else if ("QFBU".equalsIgnoreCase(excelName)) {
            //Quarterly KPI Report FBU标题
            //sheet KPI_FBU_REP_FD_C FD_S FD_P
            mapField = getBaseTitle();
            mapField.put("ab_planed_calls_ratio_m1_p", "拜访计划执行率-1");
            mapField.put("ab_planed_calls_ratio_m2_p", "拜访计划执行率-2");
            mapField.put("ab_planed_calls_ratio_m3_p", "拜访计划执行率-3");
            mapField.put("laboratory_calls_ratio_m1_p", "Tech目标客户拜访次数占比-1");
            mapField.put("laboratory_calls_ratio_m2_p", "Tech目标客户拜访次数占比-2");
            mapField.put("laboratory_calls_ratio_m3_p", "Tech目标客户拜访次数占比-3");
//            mapField.put("weshare_times_m1", "WeShare推送次数-1");
//            mapField.put("weshare_times_m2", "WeShare推送次数-2");
//            mapField.put("weshare_times_m3", "WeShare推送次数-3");
            mapField.put("department_meetings_m1", "科室会数量-1");
            mapField.put("department_meetings_m2", "科室会数量-2");
            mapField.put("department_meetings_m3", "科室会数量-3");
            //---新增
            mapField.put("central_area_meetings_m1", "中央区域及销售自办会议次数-1");
            mapField.put("central_area_meetings_m2", "中央区域及销售自办会议次数-2");
            mapField.put("central_area_meetings_m3", "中央区域及销售自办会议次数-3");

//            mapField.put("nurse_department_meeting_hcps_ratio_m1_p", "科室会覆盖的护理客户覆盖率-1");
//            mapField.put("nurse_department_meeting_hcps_ratio_m2_p", "科室会覆盖的护理客户覆盖率-2");
//            mapField.put("nurse_department_meeting_hcps_ratio_m3_p", "科室会覆盖的护理客户覆盖率-3");
//            mapField.put("ivf_report_m1", "IVF报告-1");
//            mapField.put("ivf_report_m2", "IVF报告-2");
//            mapField.put("ivf_report_m3", "IVF报告-3");
            //新增
            mapField.put("target_binding_hcps_q", "季度Weshare绑定目标医生数");
            mapField.put("target_hcp_binding_ratio_q_p", "WeShare目标客户绑定率");
            mapField.put("weshare_target_hcps_m1", "WeShare推送目标客户数-1");
            mapField.put("weshare_target_hcps_m2", "WeShare推送目标客户数-2");
            mapField.put("weshare_target_hcps_m3", "WeShare推送目标客户数-3");

            mapField.put("product_test_q", "季度产品知识考试");
            mapField.put("art_register_rate_q_p", "ART目标客户注册率");
            //新增
            mapField.put("lesson_fee_in_time_q", "讲课费报销及时性");
            mapField.put("lesson_fee_return_rate_q", "讲课费报销退单率");
            mapField.put("last_month_target_hcps_q", "目标医生数");
            mapField.put("gynecologic_target_hcps_q", "妇产科目标医生数");

            mapField.put("lab_art_register_rate_q_p", "ART实验室客户注册率");
            mapField.put("lab_ab_hco_ratio_q_p", ">=1个实验室目标客户数量的AB类医院占比");
            mapField.put("lab_others_hco_ratio_q_p", ">=1个实验室目标客户数量的Other类医院占比");
            mapField.put("ab_planed_calls_ratio_score_q_p", "拜访计划执行率得分");
            mapField.put("laboratory_calls_ratio_score_q_p", "Tech目标客户拜访得分");
//            mapField.put("weshare_times_score_q_p", "WeShare推送次数得分");
//            mapField.put("nurse_department_meeting_hcps_ratio_q_p", "科室会覆盖的护理客户覆盖率得分");
            mapField.put("art_register_rate_score_q_p", "ART客户注册率得分");
//            mapField.put("ivf_report_score_q_p", "IVF报告得分");
            mapField.put("product_test_score_q_p", "季度产品知识考试得分");
            mapField.put("lab_art_register_rate_score_q_p", "ART目标客户注册率得分");
            mapField.put("lab_hcps_hcos_ratio_score_q_p", "满足实验室目标客户数量的医院占比得分");
            //---新增
            mapField.put("target_hcp_binding_ratio_score_q_p", "WeShare目标客户绑定率得分");
            mapField.put("weshare_target_hcps_score_q_p", "WeShare推送目标客户数得分");
            mapField.put("last_month_target_hcps_score_q_p", "目标客户数量得分");
            mapField.put("lesson_fee_in_time_score_q_p", "讲课费报销及时性得分");
            mapField.put("lesson_fee_return_rate_score_q_p", "讲课费报销退单率得分");
            mapField.put("meeting", "会议执行得分");
            mapField.put("total", "总得分");
            mapTitle.put("KPI_FBU_REP_FD_C FD_S FD_P", mapField);
            //FBU_DSM_FD_BA 的sheet页
            mapField = getBaseTitle();
            mapField.put("president_director_pharmacy_calls_m1", "客户拜访-院长/科室主任/药剂科拜访次数-1");
            mapField.put("president_director_pharmacy_calls_m2", "客户拜访-院长/科室主任/药剂科拜访次数-2");
            mapField.put("president_director_pharmacy_calls_m3", "客户拜访-院长/科室主任/药剂科拜访次数-3");
            mapField.put("hospital_warning_q", "医院预警及时性");
            mapField.put("product_retention_q_p", "医院全品规保持率");
            mapField.put("cso_channel_management_q", "CSO及渠道管理");
            mapField.put("device_dealer_management_q", "器械经销商管理");
            mapField.put("product_test_q", "季度产品知识考试");
            mapField.put("daily_behavior_m1", "日常行为-1");
            mapField.put("daily_behavior_m2", "日常行为-2");
            mapField.put("daily_behavior_m3", "日常行为-3");
            mapField.put("president_diretor_pharmancy_calls_score_q_p", "客户拜访得分");
            mapField.put("hospital_warning_score_q_p", "医院预警及时性得分");
            mapField.put("product_retention_score_q_p", "医院全品规保持率得分");
            mapField.put("cso_channel_management_score_q_p", "CSO及渠道管理得分");
            mapField.put("device_dealer_management_score_q_p", "器械经销商管理得分");
            mapField.put("product_test_score_q_p", "季度产品知识考试得分");
            mapField.put("daily_behavior_score_q_p", "日常行为得分");
            mapField.put("total", "总得分");
            mapTitle.put("KPI_FBU_DSM_FD_BA", mapField);
            //sheet页 KPI_FBU_DSM_FD_S FD_C FD_P
            mapField = getBaseTitle();
            mapTitle.put("KPI_FBU_DSM_FD_S FD_C FD_P", mapField);
            mapField.put("avg_kpi_value_q_p", "下属代表KPI平均分");
            mapField.put("coaching_times_m1", "对代表的辅导数量-1");
            mapField.put("coaching_times_m2", "对代表的辅导数量-2");
            mapField.put("coaching_times_m3", "对代表的辅导数量-3");
            mapField.put("coaching_quality_m1", "对代表的辅导质量-1");
            mapField.put("coaching_quality_m2", "对代表的辅导质量-2");
            mapField.put("coaching_quality_m3", "对代表的辅导质量-3");
            mapField.put("s_call_hcps_ratio_q_p", "S级客户拜访覆盖率");
//            mapField.put("weshare_pass_reps_ratio_q_p", "weshare达标代表占比");
            mapField.put("laboratory_calls_ratio_q_p", "对重点Tech客户进行拜访");
//            mapField.put("expense_management_q_p", "费用管理");
            mapField.put("art_register_rate_q_p", "ART客户注册率");
            mapField.put("bmr_assess_q_p", "BMR评估评分");
            //新增
            mapField.put("phase_breakthrough_speaker_coverage_q", "阶段性突破中心讲者覆盖");
            mapField.put("rep_meeting_execution_rate_q", "代表会议执行达标率");
            mapField.put("lesson_fee_in_time_and_return_rate_q", "代表讲课费报销及时性和退单率");

//            mapField.put("daily_behavior_m1", "销售团队管理上级打分-1");
//            mapField.put("daily_behavior_m2", "销售团队管理上级打分-2");
//            mapField.put("daily_behavior_m3", "销售团队管理上级打分-3");
            mapField.put("product_test_q", "季度产品知识考试评分");
            mapField.put("lab_art_register_rate_q_p", "ART实验室客户注册率 ");
            mapField.put("lab_ab_hco_ratio_q_p", ">=1个实验室目标客户数量的AB类医院占比");
            mapField.put("lab_others_hco_ratio_q_p", ">=1个实验室目标客户数量的Other类医院占比");
            mapField.put("avg_kpi_finalscore_q_p", "下属代表KPI平均分得分");
            mapField.put("coaching_times_score_q_p", "对代表的辅导数量得分");
            mapField.put("s_call_hcps_ratio_score_q_p", "S级客户拜访覆盖率得分");
            mapField.put("laboratory_calls_ratio_score_q_p", "对重点Tech客户进行拜访得分");
//            mapField.put("expense_management_score_q_p", "费用管理得分");
            mapField.put("art_register_rate_score_q_p", "ART客户注册率得分");
            mapField.put("bmr_assess_score_q_p", "BMR评估得分");
//            mapField.put("daily_behavior_score_q_p", "销售团队管理上级打分得分");
//            mapField.put("weshare_pass_reps_ratio_score_q_p", "Weshare合格代表占比得分");
            mapField.put("product_test_score_q_p", "季度产品知识考试得分");
            mapField.put("lab_art_register_rate_score_q_p", "ART实验室客户注册率得分");
            mapField.put("lab_hcps_hcos_ratio_score_q_p", "满足实验室目标客户数量的医院占比得分");
            //新增
            mapField.put("phase_breakthrough_speaker_coverage_score_q_p", "阶段性突破中心讲者覆盖得分");
            mapField.put("rep_meeting_execution_rate_score_q_p", "代表会议执行达标率得分");
            mapField.put("lesson_fee_in_time_and_return_rate_score_q_p", "代表讲课费报销及时性和退单率得分");
            mapField.put("total", "总得分");
            //sheet页 KPI_FBU_FT DM_FT
            mapField = getBaseTitle();
            mapTitle.put("KPI_FBU_FT DM_FT", mapField);
            mapField.put("key_account_maintain_m1", "关键客户维护-1");
            mapField.put("key_account_maintain_m2", "关键客户维护-2");
            mapField.put("key_account_maintain_m3", "关键客户维护-3");
            mapField.put("activity_execution_q", "活动执行及市场信息收集");
            mapField.put("combination_score_m1", "联合推动-1");
            mapField.put("combination_score_m2", "联合推动-2");
            mapField.put("combination_score_m3", "联合推动-3");
            mapField.put("procurement_plan_q", "采购计划及流程跟进");
            //新增
            mapField.put("nc_team_training_q", "对NC团队的产品知识培训");
//            mapField.put("product_test_q", "季度产品知识考试");
            mapField.put("key_account_maintain_score_q_p", "关键客户维护得分");
            mapField.put("activity_execution_score_q_p", "活动执行及市场信息收集得分");
            mapField.put("combination_score_q_p", "联合推动得分");
            mapField.put("procurement_plan_score_q_p", "采购计划及流程跟进得分");
            //新增
            mapField.put("nc_team_training_score_q_p", "对NC团队的产品知识培训得分");
//            mapField.put("product_test_score_q_p", "季度产品知识考试得分");
            mapField.put("total", "总得分");
            //sheet页 KPI_FBU_RSD&NAD
            mapField = getBaseTitle();
            mapTitle.put("KPI_FBU_RSD&NAD", mapField);
            mapField.put("avg_kpi_value_q_p", "下属KPI平均分");
//            mapField.put("s_call_hcps_ratio_q_p", "S级客户拜访覆盖率");
//            mapField.put("weshare_pass_reps_ratio_q_p", "Weshare合格代表占比");
            mapField.put("art_register_rate_q_p", "ART注册客户占比");
            mapField.put("expense_management_q_p", "费用管理");
            mapField.put("turnover_rate_q_p", "销售队伍管理评估 -团队人员管理");
            mapField.put("ems_assess_q_p", "销售队伍管理评估 -EMS");
            mapField.put("transaction_management_q_p", "销售队伍管理评估 -事务管理");
            //新增
            mapField.put("event_execution_q", "活动执行");
            mapField.put("speaker_coverage_q", "讲者覆盖");

            mapField.put("avg_kpi_score_q_ps", "下属KPI平均分得分");
            mapField.put("market_share_change_score_q_p", "市场份额变化得分");
            mapField.put("art_register_rate_score_q_p", "ART客户注册率得分");
            mapField.put("expense_management_score_q_p", "费用管理得分");
//            mapField.put("s_call_hcps_ratio_score_q_p", "S级客户拜访得分");
//            mapField.put("weshare_pass_reps_ratio_score_q_p", "weshare达标代表占比得分");
            mapField.put("turnover_rate_score_q_p", "团队人员管理得分");
            mapField.put("ems_assess_score_q_p", "EMS评估得分");
            mapField.put("transaction_management_score_q_p", "事务管理得分");
            //新增
            mapField.put("event_execution_score_q_p", "活动执行得分");
            mapField.put("speaker_coverage_score_q_p", "讲者覆盖得分");
            mapField.put("total", "总得分");
        } else if ("QGBU".equalsIgnoreCase(excelName)) {
            //Quarterly KPI Report
            //sheet KPI_GBU_REP_CHD
            mapField = getBaseTitle();
            mapField.put("target_hcps_m1", "医生数_1");
            mapField.put("target_hcps_m2", "医生数_2");
            mapField.put("target_hcps_m3", "医生数_3");
            mapField.put("call_hcps_ratio_m1_p", "拜访覆盖率_1");
            mapField.put("call_hcps_ratio_m2_p", "拜访覆盖率_2");
            mapField.put("call_hcps_ratio_m3_p", "拜访覆盖率_3");
//            mapField.put("prefessional_calls_m1", "专业化拜访数 _1");
//            mapField.put("prefessional_calls_m2", "专业化拜访数 _2");
//            mapField.put("prefessional_calls_m3", "专业化拜访数 _3");
            mapField.put("administ_prefessional_calls_m1", "专业化拜访数（行政管理人员）_1");
            mapField.put("administ_prefessional_calls_m2", "专业化拜访数（行政管理人员）_2");
            mapField.put("administ_prefessional_calls_m3", "专业化拜访数（行政管理人员）_3");
            mapField.put("clinician_prefessional_calls_m1", "专业化拜访数（临床医生） _1");
            mapField.put("clinician_prefessional_calls_m2", "专业化拜访数（临床医生） _2");
            mapField.put("clinician_prefessional_calls_m3", "专业化拜访数（临床医生） _3");
            mapField.put("product_test_m1", "月度产品知识考试-1");
            mapField.put("product_test_m2", "月度产品知识考试-2");
            mapField.put("product_test_m3", "月度产品知识考试-3");
            mapField.put("call_hcps_ratio_score_q_p", "拜访覆盖率得分");
            mapField.put("prefessional_calls_score_q_p", "每月专业化拜访数 得分");
            mapField.put("product_test_score_q_p", "季度产品考试得分");
            mapField.put("total", "总得分");
            mapTitle.put("KPI_GBU_REP_CHD", mapField);
            //KPI_GBU_REP_DB_CV_MIX
            mapField = getBaseTitle();
            mapTitle.put("KPI_GBU_REP_DB_CV_MIX", mapField);
            mapField.put("target_hcps_m1", "医生数_1");
            mapField.put("target_hcps_m2", "医生数_2");
            mapField.put("target_hcps_m3", "医生数_3");
//            mapField.put("call_hcps_ratio_m1_p", "拜访计划执行率_1");
            mapField.put("planed_prefessional_calls_ratio_m1_p", "拜访计划执行率_1");
            mapField.put("planed_prefessional_calls_ratio_m2_p", "拜访计划执行率_2");
            mapField.put("planed_prefessional_calls_ratio_m3_p", "拜访计划执行率_3");
            mapField.put("daily_prefessional_calls_m1", "平均每天专业化拜访数_1");
            mapField.put("daily_prefessional_calls_m2", "平均每天专业化拜访数_2");
            mapField.put("daily_prefessional_calls_m3", "平均每天专业化拜访数_3");
            mapField.put("is_new_binding_hcps_q", "新绑定医生数");
            mapField.put("is_binding_hcps_ratio_q_p", "已绑定医生占比");
            mapField.put("is_binding_weshare_hcps_m1", "Weshare推送已绑定医生数_1");
            mapField.put("is_binding_weshare_hcps_m2", "Weshare推送已绑定医生数_2");
            mapField.put("is_binding_weshare_hcps_m3", "Weshare推送已绑定医生数_3");
            mapField.put("training_completion_q", "培训完成及时性");
            mapField.put("product_test_q", "季度产品知识考试");
            mapField.put("vbp_hap_q", "VBP考核HAP");
            mapField.put("vbp_procurement_q", "VBP考核医院采购");
            mapField.put("planed_prefessional_calls_ratio_score_q_p", "拜访计划执行率得分");
            mapField.put("daily_prefessional_calls_score_q_p", "平均每天专业化拜访数得分");
            mapField.put("is_new_binding_hcps_score_q_p", "新绑定医生数得分");
            mapField.put("is_binding_hcps_ratio_score_q_p", "Weshare推送已绑定医生数得分");
            mapField.put("training_completion_score_q_p", "培训完成及时性得分");
            mapField.put("product_test_score_q_p", "产品知识考试得分");
            mapField.put("vbp_hap_score_q_p", "VBP考核HAP得分");
            mapField.put("vbp_procurement_score_q_p", "VBP考核医院采购得分");
            mapField.put("total", "总得分");
//todo -------------------开始
            //KPI_GBU_REP_CHD_DB
            mapField = getBaseTitle();
            mapTitle.put("KPI_GBU_REP_CHD_DB", mapField);
            mapField.put("target_hcps_m1", "医生数_1");
            mapField.put("target_hcps_m2", "医生数_2");
            mapField.put("target_hcps_m3", "医生数_3");
//            mapField.put("call_hcps_ratio_m1_p", "拜访计划执行率_1");
            mapField.put("planed_prefessional_calls_ratio_m1_p", "拜访计划执行率_1");
            mapField.put("planed_prefessional_calls_ratio_m2_p", "拜访计划执行率_2");
            mapField.put("planed_prefessional_calls_ratio_m3_p", "拜访计划执行率_3");
            mapField.put("daily_prefessional_calls_m1", "平均每天专业化拜访数_1");
            mapField.put("daily_prefessional_calls_m2", "平均每天专业化拜访数_2");
            mapField.put("daily_prefessional_calls_m3", "平均每天专业化拜访数_3");
            mapField.put("is_new_binding_hcps_q", "新绑定医生数");
            mapField.put("is_binding_hcps_ratio_q_p", "已绑定医生占比");
            mapField.put("is_binding_weshare_hcps_m1", "Weshare推送已绑定医生数_1");
            mapField.put("is_binding_weshare_hcps_m2", "Weshare推送已绑定医生数_2");
            mapField.put("is_binding_weshare_hcps_m3", "Weshare推送已绑定医生数_3");
            mapField.put("training_completion_q", "培训完成及时性");
            mapField.put("product_test_q", "季度产品知识考试");
            mapField.put("vbp_hap_q", "VBP考核HAP");
            mapField.put("vbp_procurement_q", "VBP考核医院采购");
            mapField.put("planed_prefessional_calls_ratio_score_q_p", "拜访计划执行率得分");
            mapField.put("daily_prefessional_calls_score_q_p", "平均每天专业化拜访数得分");
            mapField.put("is_new_binding_hcps_score_q_p", "新绑定医生数得分");
            mapField.put("is_binding_hcps_ratio_score_q_p", "Weshare推送已绑定医生数得分");
            mapField.put("training_completion_score_q_p", "培训完成及时性得分");
            mapField.put("product_test_score_q_p", "产品知识考试得分");
            mapField.put("vbp_hap_score_q_p", "VBP考核HAP得分");
            mapField.put("vbp_procurement_score_q_p", "VBP考核医院采购得分");
            mapField.put("total", "总得分");
            //todo -------------------
            //sheet页 KPI_GBU_REP_TD_ST
            mapField = getBaseTitle();
            mapTitle.put("KPI_GBU_REP_TD_ST", mapField);
            mapField.put("target_hcps_m1", "医生数_1");
            mapField.put("target_hcps_m2", "医生数_2");
            mapField.put("target_hcps_m3", "医生数_3");
            mapField.put("planed_prefessional_calls_ratio_m1_p", "拜访计划执行率_1");
            mapField.put("planed_prefessional_calls_ratio_m2_p", "拜访计划执行率_2");
            mapField.put("planed_prefessional_calls_ratio_m3_p", "拜访计划执行率_3");
            mapField.put("daily_prefessional_calls_m1", "平均每天专业化拜访数_1");
            mapField.put("daily_prefessional_calls_m2", "平均每天专业化拜访数_2");
            mapField.put("daily_prefessional_calls_m3", "平均每天专业化拜访数_3");
            mapField.put("is_new_binding_hcps_q", "新绑定医生数");
            mapField.put("is_binding_hcps_ratio_q_p", "已绑定医生占比");
            mapField.put("is_binding_weshare_hcps_m1", "Weshare推送已绑定医生数_1");
            mapField.put("is_binding_weshare_hcps_m2", "Weshare推送已绑定医生数_2");
            mapField.put("is_binding_weshare_hcps_m3", "Weshare推送已绑定医生数_3");
            mapField.put("training_completion_q", "培训完成及时性");
            mapField.put("product_test_q", "季度产品知识考试");
            mapField.put("expand_customer_q", "扩展客户");
            mapField.put("marketing_activities_q", "市场推广活动评估");
            mapField.put("planed_prefessional_calls_ratio_score_q_p", "拜访计划执行率得分");
            mapField.put("daily_prefessional_calls_score_q_p", "平均每天专业化拜访数得分");
            mapField.put("is_new_binding_hcps_score_q_p", "新绑定医生数得分");
            mapField.put("is_binding_hcps_ratio_score_q_p", "Weshare推送已绑定医生数得分");
            mapField.put("training_completion_score_q_p", "培训完成及时性得分");
            mapField.put("product_test_score_q_p", "产品知识考试得分");
            mapField.put("expand_customer_score_q_p", "扩展客户得分");
            mapField.put("marketing_activities_score_q_p", "市场推广活动评估得分");
            mapField.put("total", "总得分");
            //sheet页 KPI_GBU_DSM_HA
            mapField = getBaseTitle();
            mapTitle.put("KPI_GBU_DSM_HA", mapField);
            mapField.put("actual_work_days_m1", "实际工作天数_1");
            mapField.put("actual_work_days_m2", "实际工作天数_2");
            mapField.put("actual_work_days_m3", "实际工作天数_3");
            mapField.put("president_calls_q", "院长拜访次数");
            mapField.put("director_calls_q", "科室主任拜访次数");
            mapField.put("hospital_warning_q", "医院预警");
            mapField.put("product_retention_q", "医院全品规保持率");
            mapField.put("training_completion_q", "培训完成及时性");
            mapField.put("product_test_q", "季度产品知识考试");
            mapField.put("actual_work_days_score_q_p", "实际工作天数得分");
            mapField.put("president_calls_score_q_p", "院长拜访次数得分");
            mapField.put("director_calls_score_q_p", "科室主任拜访次数得分");
            mapField.put("hospital_warning_score_q_p", "医院预警及时性得分");
            mapField.put("product_retention_score_q_p", "医院全品规保持率得分");
            mapField.put("training_completion_score_q_p", "培训完成及时性得分");
            mapField.put("product_test_score_q_p", "产品知识考试 得分");
            mapField.put("total", "总得分");
            //sheet页 KPI_GBU_DSM_ST_TD
            mapField = getBaseTitle();
            mapTitle.put("KPI_GBU_DSM_ST_TD", mapField);
//            mapField.put("daily_prefessional_calls_avg_kpi_score_q_p", "下属代表日均专业化拜访数平均分");
            mapField.put("daily_prefessional_calls_avg_kpi_value_q_p", "下属代表日均专业化拜访数平均分");
//            mapField.put("planed_calls_ratio_avg_kpi_score_q_p", "下属代表拜访计划率平均分");
            mapField.put("planed_calls_ratio_avg_kpi_value_q_p", "下属代表拜访计划率平均分");
//            mapField.put("weshare_avg_kpi_score_q_p", "下属代表Weshare平均分");
            mapField.put("weshare_avg_kpi_value_q_p", "下属代表Weshare平均分");
            mapField.put("coaching_coverage_m1_p", "对代表辅导覆盖率_1");
            mapField.put("coaching_coverage_m2_p", "对代表辅导覆盖率_2");
            mapField.put("coaching_coverage_m3_p", "对代表辅导覆盖率_3");
            mapField.put("coaching_quality_m1", "对代表的辅导质量-1");
            mapField.put("coaching_quality_m2", "对代表的辅导质量-2");
            mapField.put("coaching_quality_m3", "对代表的辅导质量-3");
            mapField.put("marketing_activities_q", "市场准入合作得分(ST)/市场推广活动(TD)");
            mapField.put("training_completion_q", "培训完成及时性");
            mapField.put("product_test_q", "季度产品知识考试 ");
            mapField.put("daily_prefessional_calls_avg_kpi_score_q_ps", "下属代表日均专业化拜访数平均分得分 ");
            mapField.put("planed_calls_ratio_avg_kpi_score_q_ps", "下属代表拜访计划率平均分得分");
            mapField.put("weshare_avg_kpi_score_q_ps", "下属代表Weshare平均分得分");
            mapField.put("coaching_coverage_score_q_p", "被辅导代表的覆盖率得分");
            mapField.put("coaching_quality_score_q_p", "辅导质量得分");
            mapField.put("marketing_activities_score_q_p", "市场准入合作得分(ST)/市场推广活动(TD)");
            mapField.put("training_completion_score_q_p", "培训完成及时性得分");
            mapField.put("product_test_score_q_p", "产品知识考试 得分");
            mapField.put("total", "总得分");
            //sheet页 KPI_GBU_DSM_DB_CV_MIX_CHD
            mapField = getBaseTitle();
            mapTitle.put("KPI_GBU_DSM_DB_CV_MIX_CHD", mapField);
//            mapField.put("prefessional_calls_avg_kpi_score_q_p", "下属代表每月专业化拜访数平均分");
            mapField.put("prefessional_calls_avg_kpi_value_q_p", "下属代表每月专业化拜访数平均分");
//            mapField.put("daily_prefessional_calls_avg_kpi_score_q_p", "下属代表日均专业化拜访数平均分");
            mapField.put("daily_prefessional_calls_avg_kpi_value_q_p", "下属代表日均专业化拜访数平均分");
//            mapField.put("call_hcps_ratio_avg_kpi_finalscore_q_p", "下属代表拜访覆盖率平均分");
            mapField.put("call_hcps_ratio_avg_kpi_value_q_p", "下属代表拜访覆盖率平均分");
//            mapField.put("planed_calls_ratio_avg_kpi_score_q_p", "下属代表拜访计划率平均分");
            mapField.put("planed_calls_ratio_avg_kpi_value_q_p", "下属代表拜访计划率平均分");
//            mapField.put("weshare_avg_kpi_score_q_p", "下属代表Weshare平均分");
            mapField.put("weshare_avg_kpi_value_q_p", "下属代表Weshare平均分");
            mapField.put("coaching_coverage_m1_p", "对代表辅导覆盖率_1");
            mapField.put("coaching_coverage_m2_p", "对代表辅导覆盖率_2");
            mapField.put("coaching_coverage_m3_p", "对代表辅导覆盖率_3");
            mapField.put("coaching_quality_m1", "对代表的辅导质量-1");
            mapField.put("coaching_quality_m2", "对代表的辅导质量-2");
            mapField.put("coaching_quality_m3", "对代表的辅导质量-3");
            mapField.put("vbp_hap_q", "VBP考核HAP");
            mapField.put("vbp_procurement_q", "VBP考核医院采购");
            mapField.put("training_completion_q", "培训完成及时性");
            mapField.put("product_test_q", "季度产品知识考试");
            mapField.put("prefessional_calls_avg_kpi_score_q_ps", "下属代表每月专业化拜访数平均分得分");
            mapField.put("daily_prefessional_calls_avg_kpi_score_q_ps", "下属代表日均专业化拜访数平均分得分");
                mapField.put("call_hcps_ratio_avg_kpi_finalscore_q_ps", "下属代表拜访覆盖率平均分得分");
            mapField.put("planed_calls_ratio_avg_kpi_score_q_ps", "下属代表拜访计划率平均分得分");
            mapField.put("weshare_avg_kpi_score_q_ps", "下属代表Weshare平均分得分");
            mapField.put("coaching_coverage_score_q_p", "对代表辅导覆盖率得分");
            mapField.put("coaching_quality_score_q_p", "对代表的辅导质量得分");
            mapField.put("vbp_hap_score_q_p", "VBP考核HAP得分");
            mapField.put("vbp_procurement_score_q_p", "VBP考核医院采购得分");
            mapField.put("training_completion_score_q_p", "培训完成及时性得分");
            mapField.put("product_test_score_q_p", "季度产品知识考试 得分");
            mapField.put("total", "总得分");
            //sheet页 KPI_GBU_RSM
            mapField = getBaseTitle();
            mapTitle.put("KPI_GBU_RSM", mapField);
            mapField.put("avg_kpi_value_q_p", "下属KPI平均分");
            mapField.put("avg_kpi_score_q_ps", "下属平均KPI得分");
            mapField.put("expense_management_score_q_p", "YTD费用使用率得分");
            mapField.put("regional_promotion_score_q_p", "区域推广执行评估得分");
            mapField.put("vbp_hap_score_q_p", "VBP考核HAP得分");
            mapField.put("vbp_procurement_score_q_p", "VBP考核医院采购得分");
            mapField.put("turnover_rate_score_q_p", "YTD离职率得分");
            mapField.put("talent_retaining_score_q_p", "人员保留和招聘评估得分");
            mapField.put("management_ability_score_q_p", "管理能力综合评分得分");
            mapField.put("total", "总得分");
        } else if ("QKA".equalsIgnoreCase(excelName)) {
            //sheet页 KPI_KA_DSM_KA
            mapField = getBaseTitle();
            mapTitle.put("KPI_KA_DSM_KA", mapField);
            mapField.put("director_calls_q", "客户拜访_科室主任次数");
            mapField.put("president_calls_q", "客户拜访_院长次数");
            mapField.put("event_times_q", "活动管理_数量");
            mapField.put("attended_attendees_q", "活动管理_质量_季度实际参会人数");
            mapField.put("attended_attendees_ratio_q_p", "活动管理_质量_客户参会率");
            mapField.put("product_test_q", "季度产品知识考试");
            mapField.put("president_calls_score_q_p", "客户拜访_院长得分");
            mapField.put("director_calls_score_q_p", "客户拜访_科室主任得分");
            mapField.put("event_times_score_q_p", "活动管理_数量得分");
            mapField.put("attended_attendees_ratio_score_q_p", "活动管理_质量得分");
            mapField.put("product_test_score_q_p", "季度产品知识考试得分");
            mapField.put("total", "总得分");
        }


        return mapTitle;

    }



    public static Map<String, Map<String, String>> getMonthTitleMap(String excelName){
        Map<String,Map<String, String>>  mapTitle = new LinkedHashMap<>();
        Map<String, String> mapField = null;
        //2021 Q1 Quarterly KPI Report OBU
        if ("MFBU".equalsIgnoreCase(excelName)) {
            //sheet KPI_FBU_REP_FD_C FD_S FD_P
            mapField = getBaseTitle();
            mapTitle.put("KPI_FBU_REP_FD_C FD_S FD_P", mapField);
            mapField.put("ab_planed_calls_ratio_m1_p", "拜访计划执行率-1");
            mapField.put("ab_planed_calls_ratio_m2_p", "拜访计划执行率-2");
            mapField.put("ab_planed_calls_ratio_m3_p", "拜访计划执行率-3");
            mapField.put("laboratory_calls_ratio_m1_p", "Tech目标客户拜访次数占比-1");
            mapField.put("laboratory_calls_ratio_m2_p", "Tech目标客户拜访次数占比-2");
            mapField.put("laboratory_calls_ratio_m3_p", "Tech目标客户拜访次数占比-3");
//            mapField.put("weshare_times_m1", "WeShare推送次数-1");
//            mapField.put("weshare_times_m2", "WeShare推送次数-2");
//            mapField.put("weshare_times_m3", "WeShare推送次数-3");
            mapField.put("department_meetings_m1", "科室会数量-1");
            mapField.put("department_meetings_m2", "科室会数量-2");
            mapField.put("department_meetings_m3", "科室会数量-3");
//            mapField.put("nurse_department_meeting_hcps_ratio_m1_p", "科室会覆盖的护理客户覆盖率-1");
//            mapField.put("nurse_department_meeting_hcps_ratio_m2_p", "科室会覆盖的护理客户覆盖率-2");
//            mapField.put("nurse_department_meeting_hcps_ratio_m3_p", "科室会覆盖的护理客户覆盖率-3");
            mapField.put("lab_ab_hco_ratio_q_p", ">=1个实验室目标客户数量的AB类医院占比");
            mapField.put("lab_others_hco_ratio_q_p", ">=1个实验室目标客户数量的Other类医院占比");
            //--新增
            mapField.put("target_binding_hcps_m1", "WeShare目标绑定医生数-1");
            mapField.put("target_binding_hcps_m2", "WeShare目标绑定医生数-2");
            mapField.put("target_binding_hcps_m3", "WeShare目标绑定医生数-3");
            mapField.put("target_hcp_binding_ratio_m1", "WeShare目标客户绑定率-1");
            mapField.put("target_hcp_binding_ratio_m2", "WeShare目标客户绑定率-2");
            mapField.put("target_hcp_binding_ratio_m3", "WeShare目标客户绑定率-3");
            mapField.put("weshare_target_hcps_m1", "WeShare推送目标客户数-1");
            mapField.put("weshare_target_hcps_m2", "WeShare推送目标客户数-2");
            mapField.put("weshare_target_hcps_m3", "WeShare推送目标客户数-3");
            mapField.put("target_hcps_m1", "目标医生数-1");
            mapField.put("target_hcps_m2", "目标医生数-2");
            mapField.put("target_hcps_m3", "目标医生数-3");
            mapField.put("gynecologic_target_hcps_m1", "妇产科目标医生数-1");
            mapField.put("gynecologic_target_hcps_m2", "妇产科目标医生数-2");
            mapField.put("gynecologic_target_hcps_m3", "妇产科目标医生数-3");
            //sheet 页 KPI_FBU_DSM_FD_BA
            mapField = getBaseTitle();
            mapTitle.put("KPI_FBU_DSM_FD_BA", mapField);
            mapField.put("president_director_pharmacy_calls_m1", "客户拜访-院长/科室主任/药剂科拜访次数-1");
            mapField.put("president_director_pharmacy_calls_m2", "客户拜访-院长/科室主任/药剂科拜访次数-2");
            mapField.put("president_director_pharmacy_calls_m3", "客户拜访-院长/科室主任/药剂科拜访次数-3");

            //sheet 页 KPI_FBU_DSM_FD_S FD_C FD_P
            mapField = getBaseTitle();
            mapTitle.put("KPI_FBU_DSM_FD_S FD_C FD_P", mapField);
            mapField.put("coaching_times_m1", "对代表的辅导数量-1");
            mapField.put("coaching_times_m2", "对代表的辅导数量-2");
            mapField.put("coaching_times_m3", "对代表的辅导数量-3");
            mapField.put("s_call_hcps_ratio_q_p", "S级客户拜访覆盖率");
//            mapField.put("weshare_pass_reps_ratio_q_p", "weshare达标代表占比");
            mapField.put("lab_ab_hco_ratio_q_p", ">=1个实验室目标客户数量的AB类医院占比");
            mapField.put("lab_others_hco_ratio_q_p", ">=1个实验室目标客户数量的Other类医院占比");

            //sheet KPI_FBU_RSD&NAD
//            mapField = getBaseTitle();
//            mapTitle.put("KPI_FBU_RSD&NAD", mapField);
//            mapField.put("s_call_hcps_ratio_q_p", "S级客户拜访覆盖率");
//            mapField.put("weshare_pass_reps_ratio_q_p", "weshare达标代表占比");
        } else if ("MGBU".equalsIgnoreCase(excelName)) {
            //sheet KPI_GBU_REP_CHD
            mapField = getBaseTitle();
            mapTitle.put("KPI_GBU_REP_CHD", mapField);
            mapField.put("target_hcps_m1", "医生数_1");
            mapField.put("target_hcps_m2", "医生数_2");
            mapField.put("target_hcps_m3", "医生数_3");
            mapField.put("call_hcps_ratio_m1_p", "拜访覆盖率_1");
            mapField.put("call_hcps_ratio_m2_p", "拜访覆盖率_2");
            mapField.put("call_hcps_ratio_m3_p", "拜访覆盖率_3");
            mapField.put("administ_prefessional_calls_m1", "专业化拜访数（行政管理人员）_1");
            mapField.put("administ_prefessional_calls_m2", "专业化拜访数（行政管理人员）_2");
            mapField.put("administ_prefessional_calls_m3", "专业化拜访数（行政管理人员）_3");
            mapField.put("clinician_prefessional_calls_m1", "专业化拜访数（临床医生）_1");
            mapField.put("clinician_prefessional_calls_m2", "专业化拜访数（临床医生）_2");
            mapField.put("clinician_prefessional_calls_m3", "专业化拜访数（临床医生）_3");
            //KPI_GBU_REP_DB_CV_MIX_TD_ST
            mapField = getBaseTitle();
            mapTitle.put("KPI_GBU_REP_DB_CV_MIX_TD_ST", mapField);
            mapField.put("target_hcps_m1", "医生数_1");
            mapField.put("target_hcps_m2", "医生数_2");
            mapField.put("target_hcps_m3", "医生数_3");
            mapField.put("planed_prefessional_calls_ratio_m1_p", "拜访计划执行率_1");
            mapField.put("planed_prefessional_calls_ratio_m2_p", "拜访计划执行率_2");
            mapField.put("planed_prefessional_calls_ratio_m3_p", "拜访计划执行率_3");
            mapField.put("daily_prefessional_calls_m1", "平均每天专业化拜访数_1");
            mapField.put("daily_prefessional_calls_m2", "平均每天专业化拜访数_2");
            mapField.put("daily_prefessional_calls_m3", "平均每天专业化拜访数_3");
            mapField.put("is_new_binding_hcps_q", "新绑定医生数");
            mapField.put("is_binding_hcps_ratio_q_p", "已绑定医生占比");
            mapField.put("is_binding_weshare_hcps_m1", "Weshare推送已绑定医生数_1");
            mapField.put("is_binding_weshare_hcps_m2", "Weshare推送已绑定医生数_2");
            mapField.put("is_binding_weshare_hcps_m3", "Weshare推送已绑定医生数_3");
            //KPI_GBU_DSM_HA
            mapField = getBaseTitle();
            mapTitle.put("KPI_GBU_DSM_HA", mapField);
            mapField.put("actual_work_days_m1", "实际工作天数_1");
            mapField.put("actual_work_days_m2", "实际工作天数_2");
            mapField.put("actual_work_days_m3", "实际工作天数_3");
            //sheet KPI_GBU_DSM_ST_TD_DB_CV_MIX_CHD
            mapField = getBaseTitle();
            mapTitle.put("KPI_GBU_DSM_ST_TD_DB_CV_MIX_CHD", mapField);
            mapField.put("coaching_coverage_m1_p", "对代表辅导覆盖率_1");
            mapField.put("coaching_coverage_m2_p", "对代表辅导覆盖率_2");
            mapField.put("coaching_coverage_m3_p", "对代表辅导覆盖率_3");
        } else if ("MOBU".equalsIgnoreCase(excelName)) {
            //sheet KPI_OBU_REP_Erbitux
            mapField = getBaseTitle();
            mapTitle.put("KPI_OBU_REP_Erbitux", mapField);
            mapField.put("actual_work_days_ratio_m1_p", "实际工作天数比率-1");
            mapField.put("actual_work_days_ratio_m2_p", "实际工作天数比率-2");
            mapField.put("actual_work_days_ratio_m3_p", "实际工作天数比率-3");
            mapField.put("target_hcps_m1", "目标医生数-1");
            mapField.put("target_hcps_m2", "目标医生数-2");
            mapField.put("target_hcps_m3", "目标医生数-3");
            mapField.put("ab_call_hcps_ratio_m1_p", "AB目标客户覆盖率-1");
            mapField.put("ab_call_hcps_ratio_m2_p", "AB目标客户覆盖率-2");
            mapField.put("ab_call_hcps_ratio_m3_p", "AB目标客户覆盖率-3");
            mapField.put("call_hcps_ratio_m1_p", "总目标客户覆盖率-1");
            mapField.put("call_hcps_ratio_m2_p", "总目标客户覆盖率-2");
            mapField.put("call_hcps_ratio_m3_p", "总目标客户覆盖率-3");
            mapField.put("daily_actual_calls_m1", "每日平均拜访次数-1");
            mapField.put("daily_actual_calls_m2", "每日平均拜访次数-2");
            mapField.put("daily_actual_calls_m3", "每日平均拜访次数-3");
            mapField.put("is_new_binding_hcps_q", "新绑定医生数");
            mapField.put("is_binding_hcps_ratio_q_p", "已绑定医生占比");
            mapField.put("is_binding_weshare_hcps_m1", "Weshare推送已绑定医生数-1");
            mapField.put("is_binding_weshare_hcps_m2", "Weshare推送已绑定医生数-2");
            mapField.put("is_binding_weshare_hcps_m3", "Weshare推送已绑定医生数-3");
            //sheet KPI_OBU_REP_Xalkori
            mapField = getBaseTitle();
            mapTitle.put("KPI_OBU_REP_Xalkori", mapField);
            mapField.put("actual_calls_m1", "月度拜访 -1");
            mapField.put("actual_calls_m2", "月度拜访 -2");
            mapField.put("actual_calls_m3", "月度拜访 -3");
            //sheet页 KPI_OBU_DSM
            mapField = getBaseTitle();
            mapTitle.put("KPI_OBU_DSM", mapField);
            mapField.put("actual_work_days_ratio_m1_p", "实际工作天数比率-1");
            mapField.put("actual_work_days_ratio_m2_p", "实际工作天数比率-2");
            mapField.put("actual_work_days_ratio_m3_p", "实际工作天数比率-3");
            mapField.put("coaching_times_m1", "对代表的辅导频率-1");
            mapField.put("coaching_times_m2", "对代表的辅导频率-2");
            mapField.put("coaching_times_m3", "对代表的辅导频率-3");
        }
        return mapTitle;
    }

    private static Map<String, String> getBaseTitle() {
        Map<String, String> mapField = new LinkedHashMap<>();
        mapField.put("year_id", "年");
        mapField.put("quarter_id", "季度");
        mapField.put("bu", "BU");
        mapField.put("kpi_role", "Role");
        mapField.put("position", "Position");
        mapField.put("region_name", "RegionName");
        mapField.put("territory_code", "PositionID");
        mapField.put("muid", "MUID");
        mapField.put("name", "姓名");
        mapField.put("manager", "上级经理");
        mapField.put("on_job_months", "在岗月份数");
        return mapField;
    }

    /**
     * 获取日志表头
     * @return
     */
    public static Map<String, Map<String, String>> getLogTitleMap(){
        Map<String,Map<String, String>>  mapTitle = new LinkedHashMap<>();
        Map<String, String> mapField = new LinkedHashMap<>();
        mapTitle.put("sheet1", mapField);
        mapField.put("batch_id", "batch_id");
        mapField.put("sp_name", "sp_name");
        mapField.put("start_time", "start_time");
        mapField.put("end_time", "end_time");
        mapField.put("status", "status");
        mapField.put("err_msg", "err_msg");
        mapField.put("exec_sql", "exec_sql");

        return mapTitle;
    }
}
